package com.ccsu.joysport.repository;

import com.ccsu.joysport.entity.Results;
import org.apache.ibatis.annotations.Param;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import javax.xml.transform.Result;
import java.util.List;

public interface ResultRepository extends JpaRepository<Results, String> {

    @Query("SELECT r FROM Results r WHERE r.StudentNumber = :studentNumber")
    List<Results> findByStudentNumber(@Param("studentNumber") String studentNumber);
}
